select * from C0053DEVD/F41021
where
LIMCU='         590'
and
LIPQOH>0 and LIPCOM>1 AND LIHCOM>1


select IBLITM from C0053DEVD/F4102
Where
IBITM in (select LIITM from C0053DEVD/F41021
where
LIMCU='         590'
and
LIPQOH>0 and LIPCOM>1 AND LIHCOM>1
)


select * FROM C0053DEVD/F4211
where
SDLITM='160042'
AND SDLOTN='200912160141'


select IBLITM from C0053PRDD/F4102
Where
IBITM in (select LIITM from C0053PRDD/F41021
where
LIMCU='         590'
and
LIPQOH>0 and LIPCOM>1 AND LIHCOM>1
)
